﻿/****************************************************************************************************
 **        Name: LoadedAssembly
 ** Description: Information on the assemblies loaded when an exception was raised.
 ****************************************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  11/30/2008  Chad Green             11774    Initial Development
 ****************************************************************************************************/

CREATE TABLE dbo.LoadedAssembly
(
	ID             int           NOT NULL IDENTITY(1,1),
	AssemblyInfoID int           NOT NULL,
	FullName       nVarChar(MAX) NOT NULL,
	Location       nVarChar(MAX) NOT NULL
)
GO

EXEC sp_addextendedproperty N'MS_Description', N'Information on the assemblies loaded when an exception was raised.', 'SCHEMA', N'dbo', 'TABLE', N'LoadedAssembly', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'System generated identifier for the LoadedAssembly record.', 'SCHEMA', N'dbo', 'TABLE', N'LoadedAssembly', 'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign Key - Identifier of the associated AssemblyInfo record.', 'SCHEMA', N'dbo', 'TABLE', N'LoadedAssembly', 'COLUMN', N'AssemblyInfoID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The display name of the assembly.', 'SCHEMA', N'dbo', 'TABLE', N'LoadedAssembly', 'COLUMN', N'FullName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The path or UNC location of the loaded file that contains the manifest.', 'SCHEMA', N'dbo', 'TABLE', N'LoadedAssembly', 'COLUMN', N'Location'
GO